Table of Content
DECLARATION.
APPROVAL
ACKNOWLEDGEMENT iii
ABSTRACT viii
CHAPTER ONE 1
1.0 Introduction 1
1. 1 Background ofthe study i
1.2 Statement ofthe problem 2
1.3.1 General objectives 3
1.3.2 Specific objectives 3
1.4 Scope ofthe study 3
1.5 Significance ofthe study 4
1.6 Conceptual framework 5
CHAPTER TWO 6
Literature review 6
2.0 Introduction 6
2.1 Review ofthe related literature 6
2.2 Database 8
2.2.1 Database system 9
2.2.2 Database Management System (DBMS) 9
2.3 Recent development 11
2.3.1. Internet Booking Engine (IBE) use videcom to make online reservation .11
2.4 Problem area 12
2.5 Application area 12
2.6 Conclusion 13
CHAPTER THREE 14
Methodology 14
3.0. Introduction 14
3.1. Organization unit to be studied 14
3.2. Study population 14
3.3 Sample size 14
3.4. Data collection procedures! tools 15
iv
3.4.1. Primary methods .15
3.4.2. Secondary method 16
3.5 Data analysis and analysis of user requirement 17
3.6 Development methodology 17
3.7. Design technique and tools 18
3.8. Development tools for the system 19
3.8.1 Other tools which were used are 21
3.9. Information system plan 22
3.9.1. Feasibility analysis 22
3.9.2. Project plan and schedule 22
3.9.3. Risk assessment 23
3.10. Conclusion 24
CHAPTER FOUR 25
Analysis and Design of the New System 25
4.0 Introduction 25
4.1 Requirements analysis and specification 25
4.1.1 Functional requirements 25
4.1.2 Non-functional requirements 26
4.2 System designing 28
4.2.1 Database design 28
4.2.1.1 Logical Design 28
4.2.1.2 Entity relation diagram of a new system 28
4.2.1.3 Database entities 29
4.2.1.4 Entity relationships 30
4.2.1.5 Entity relationship table 30
4.2.1.6 Entity relationship diagram 31
4.2.1.2 Physical design 32
4.2.1.2.1 Customer table 32
4.2.1.2.2 Offer table 34
4.2.1.2.3 User table 35
4.2.1.2.4 Flights table 35
4.2.2 Interface design 37
4.2.2.1 Customer home/main pageS 37
4.2.2.2 Booking page 38
4.2.2.3 Booking flight-personal details 39
4.2.2.4 Confirmation page 40
4.2.2.5 Flight details page~ 41
V
4.2.2.6 Administrator pages: .42
4.2.2.7 Configuration page 43
4.2.2.8 Customer maintenance page 45
4.3 System testing: - Testing the developed system 46
4.4 System implementation: 47
4.5 System Conversion 47
CHAPTER FIVE 48
5.1 Introduction 48
5.2 Lessons learnt 48
5.3 Limitation of the study 48
5.4 Recommendations 49
5.5 Conclusion 49
APPENDICES 5o
APPENDIX I: Guiding Questions for the staffs at booking office 50
APPENDIX II: Guiding Questions for Customers 51
APPENDIX III: Code for the customer home page 52
APPENDIX IV: Code for the booking page 58
APPENDIX V: Code for the booking flight/personal detail page 63
APPENDIX VI: Project Cost 70
APENDIX VII: Project Plan and Schedule 71
APENDIX VIII : References 72
ABSTRACT This project aimed at the design and implementation of online airline booking; a system to aid in the management and operation of the customer service. Online airline booking system is one of the essential applications of E-commerce. With the development of internet and security technology, more and more people begin to consume online, which is more convenient and personal than traditional way. Online airline booking systems which are not carefully designed basing on good security practices may lead to data loss, misplacement, inconsistencies and redundancies. Methods that were used to gather information about the current system includes; unstructured interviews, document analysis and observation. It gives detailed review of the selected methods instruments of data analysis and presentations that were used when analyzing and designing ofthe new system. The method applied attempted to establish and analyze the status of the problem, appraising it effectiveness where problems existed, to try and find solutions. The study was carried out at ATC, Entebbe branch as a case study. The system was written in PHP/MySQL and designed with user friendly interface that would ensure ease of use and avoid errors and other shortfalls that arise with the classic file system. The literature review elaborates and gives a detailed perspective of online booking system, dynamic websites and database as viewed by different authors and researchers, effects and benefits of databases and data management system.
